﻿CREATE TABLE [dbo].[Resource] (
    [ResourceID]    INT            IDENTITY (1, 1) NOT NULL,
    [LocationID]    SMALLINT       NOT NULL,
    [RessourceName] NVARCHAR (100) NOT NULL,
    [SSNo]          NVARCHAR (50)  NULL,
    [MachineTypeID] SMALLINT       NULL,
    [Status]        NVARCHAR (50)  NULL,
    [SerialNo]      NVARCHAR (50)  NULL
);

